home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / vvbusprobedetail.sql < prev    next >
Text File  |  2000-05-09  |  2KB  |  52 lines
  1.  
  2. CREATE OR REPLACE VIEW VVBUSPROBEDETAIL AS SELECT /*PROBEHIST.pdate,
  3.     PROBEHIST.conversion_num,
  4.     PROBEHIST.cbintent pull,*/
  5.     CONVERT.END_DATE pdate,
  6.     CONVERT.CONVERSION_NUM,
  7.     DECODE(PROBEHIST.CBINTENT, NULL, 0,     PROBEHIST.cbintent) pull,
  8.     vvbpmoneydet.probedcash,
  9.     vvbpmoneydet.cents_$,
  10.     vvbpmoneydet.nickels_$,
  11.     vvbpmoneydet.dimes_$,
  12.     vvbpmoneydet.quarters_$,
  13.     vvbpmoneydet.halfs_$,
  14.     vvbpmoneydet.sbas_$,
  15.     vvbpmoneydet.sm_tokens,
  16.     vvbpmoneydet.lg_tokens,
  17.     vvbpmoneydet.coin_total,
  18.     vvbpmoneydet.ones_$,
  19.     vvbpmoneydet.fives_$,
  20.     vvbpmoneydet.tens_$,
  21.     vvbpmoneydet.twenties_$,
  22.     vvbpmoneydet.bill_total,
  23.     vvbpmoneydet.t_cents_$,
  24.     vvbpmoneydet.t_nickels_$,
  25.     vvbpmoneydet.t_dimes_$,
  26.     vvbpmoneydet.t_quarters_$,
  27.     vvbpmoneydet.t_halfs_$,
  28.     vvbpmoneydet.t_sbas_$,
  29.     vvbpmoneydet.t_sm_tokens,
  30.     vvbpmoneydet.t_lg_tokens,
  31.     vvbpmoneydet.t_coin_total,
  32.     vvbpmoneydet.t_ones_$,
  33.     vvbpmoneydet.t_fives_$,
  34.     vvbpmoneydet.t_tens_$,
  35.     vvbpmoneydet.t_twenties_$,
  36.     vvbpmoneydet.t_bill_total,
  37.     vvbpmoneydet.totalcash,
  38.     vvbpmoneydet.cashbox_glid,
  39.     vvbpmoneydet.close_count,
  40.     vprevinsert.insert_date,
  41.     CONVERT.farebox_GLID  ,
  42.         BUS.BUS_ID  ,
  43.         GARAGE.GARAGE_ID
  44. FROM CONVERT, PROBEHIST, vvbpmoneydet , vprevinsert ,  FAREBOX, BUS , GARAGE
  45. WHERE /* probehist */ CONVERT.conversion_num = vvbpmoneydet.conversion_num AND
  46.     vvbpmoneydet.conversion_num = vprevinsert.conversion_num(+) AND
  47.     vvbpmoneydet.close_count = vprevinsert.close_count(+) AND
  48.     CONVERT.CONVERSION_NUM = PROBEHIST.CONVERSION_NUM(+) AND
  49.     /*PROBEHIST*/ CONVERT.FAREBOX_GLID = FAREBOX.GLID AND
  50.         FAREBOX.LOCATION = BUS.GLID  AND
  51.         BUS.GARAGEID = GARAGE.GLID
  52.